Functions And Formula in Ms- Excel


 
 
Concept Explanation
 

Functions And Formula in Ms- Excel

In Microsoft Excel, a formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division.

Formula is an expression that calculates values in a cell or in a range of cells.

               For example, =A1+A2+A3+A4 is a formula that adds up the values in cells A1 through A4.

Whereas,

.... (More Text Available, Login?)
Sample Questions
(More Questions for each concept available in Login)
Question : 1

Which of the following formula contains an error?

Right Option : C
View Explanation
Explanation
Question : 2

When you know what answer you want but do not know the exact input for that answer, which Excel tool could you use to do the same ?

Right Option : D
View Explanation
Explanation
Question : 3

In MS Excel___________________ function is used to calculate total characters in a cell.

Right Option : A
View Explanation
Explanation
 
 
 


Students / Parents Reviews [10]